﻿CREATE TABLE [dbo].[ClaimType] (
    [ClaimTypeId]     INT           IDENTITY (1, 1) NOT NULL,
    [ApplicationId]   INT           CONSTRAINT [DF_ClaimType_EnterpriseId] DEFAULT ((1)) NOT NULL,
    [Name]            VARCHAR (50)  NOT NULL,
    [Uri]             VARCHAR (150) NOT NULL,
    [adt_DateCreated] DATETIME      CONSTRAINT [DF_ClaimType_adt_DateCreated] DEFAULT (getdate()) NOT NULL,
    [adt_CreatedBy]   VARCHAR (50)  NULL,
    CONSTRAINT [PK_ClaimType_1] PRIMARY KEY CLUSTERED ([ClaimTypeId] ASC)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_ClaimType]
    ON [dbo].[ClaimType]([ApplicationId] ASC, [Name] ASC);

